public marks

PUBLIC MARKS from "Xavier Lacot" with tags drupal & delay

25 August 2007 11:30

Database replication lag | Dries Buytaert

Consider the following pseudo-code: $nid = node_save($data); $node = node_load($nid); Because node_save() executes a mutator query (an INSERT or UPDATE statement) is has to be executed on the master, so the master can propagate the changes to the slaves. Because node_load() uses a read-only query, it can go to the master or any of the available slaves. Because of the lack of synchronization between master and slaves, there is one obvious caveat: when we execute node_load() the slaves might not have been updated.

Xavier Lacot's TAGS related to tag drupal

architecture +   cms +   code +   database +   delay +   miracle +   mobile +   mysql +   php +   Point Of View +   pov +   python +   replication +   rest +   script +   service +   synchronization +   titanium +   web service +